Summary data stasiun Guanyuan

Dataset statistics

Number of variables	18
Number of observations	35064
Missing cells	5279
Missing cells (%)	0.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.8 MiB
Average record size in memory	144.0 B

Variable types

Numeric	15
Categorical	3

Alerts

`station` has constant value ""	Constant
`CO` is highly overall correlated with `NO2` and 3 other fields	High correlation
`DEWP` is highly overall correlated with `PRES` and 1 other fields	High correlation
`NO2` is highly overall correlated with `CO` and 5 other fields	High correlation
`No` is highly overall correlated with `year`	High correlation
`O3` is highly overall correlated with `NO2` and 1 other fields	High correlation
`PM10` is highly overall correlated with `CO` and 3 other fields	High correlation
`PM2.5` is highly overall correlated with `CO` and 3 other fields	High correlation
`PRES` is highly overall correlated with `DEWP` and 1 other fields	High correlation
`SO2` is highly overall correlated with `CO` and 3 other fields	High correlation
`TEMP` is highly overall correlated with `DEWP` and 2 other fields	High correlation
`WSPM` is highly overall correlated with `NO2`	High correlation
`year` is highly overall correlated with `No`	High correlation
`PM2.5` has 616 (1.8%) missing values	Missing
`PM10` has 429 (1.2%) missing values	Missing
`SO2` has 474 (1.4%) missing values	Missing
`NO2` has 659 (1.9%) missing values	Missing
`CO` has 1753 (5.0%) missing values	Missing
`O3` has 1173 (3.3%) missing values	Missing
`RAIN` is highly skewed (γ1 = 34.71933563)	Skewed
`No` is uniformly distributed	Uniform
`No` has unique values	Unique
`hour` has 1461 (4.2%) zeros	Zeros
`RAIN` has 33664 (96.0%) zeros	Zeros
`WSPM` has 1353 (3.9%) zeros	Zeros

Reproduction

Analysis started	2024-03-08 05:10:24.121740
Analysis finished	2024-03-08 05:11:03.813935
Duration	39.69 seconds
Software version	ydata-profiling vv4.6.5
Download configuration	config.json

No
Real number (ℝ)

HIGH CORRELATION UNIFORM UNIQUE

Distinct	35064
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17532.5

Minimum	1
Maximum	35064
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1754.15
Q1	8766.75
median	17532.5
Q3	26298.25
95-th percentile	33310.85
Maximum	35064
Range	35063
Interquartile range (IQR)	17531.5

Descriptive statistics

Standard deviation	10122.249
Coefficient of variation (CV)	0.57734204
Kurtosis	-1.2
Mean	17532.5
Median Absolute Deviation (MAD)	8766
Skewness	0
Sum	6.1475958 × 10⁸
Variance	1.0245993 × 10⁸
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
23379	1	< 0.1%
23373	1	< 0.1%
23374	1	< 0.1%
23375	1	< 0.1%
23376	1	< 0.1%
23377	1	< 0.1%
23378	1	< 0.1%
23380	1	< 0.1%
23422	1	< 0.1%
Other values (35054)	35054	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
35064	1	< 0.1%
35063	1	< 0.1%
35062	1	< 0.1%
35061	1	< 0.1%
35060	1	< 0.1%
35059	1	< 0.1%
35058	1	< 0.1%
35057	1	< 0.1%
35056	1	< 0.1%
35055	1	< 0.1%

year
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	274.1 KiB

2016	8784
2014	8760
2015	8760
2013	7344
2017	1416

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	140256
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2013
2nd row	2013
3rd row	2013
4th row	2013
5th row	2013

Common Values

Value	Count	Frequency (%)
2016	8784	25.1%
2014	8760	25.0%
2015	8760	25.0%
2013	7344	20.9%
2017	1416	4.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2016	8784	25.1%
2014	8760	25.0%
2015	8760	25.0%
2013	7344	20.9%
2017	1416	4.0%

Most occurring characters

Value	Count	Frequency (%)
2	35064	25.0%
0	35064	25.0%
1	35064	25.0%
6	8784	6.3%
4	8760	6.2%
5	8760	6.2%
3	7344	5.2%
7	1416	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	140256	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	35064	25.0%
0	35064	25.0%
1	35064	25.0%
6	8784	6.3%
4	8760	6.2%
5	8760	6.2%
3	7344	5.2%
7	1416	1.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	140256	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	35064	25.0%
0	35064	25.0%
1	35064	25.0%
6	8784	6.3%
4	8760	6.2%
5	8760	6.2%
3	7344	5.2%
7	1416	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140256	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	35064	25.0%
0	35064	25.0%
1	35064	25.0%
6	8784	6.3%
4	8760	6.2%
5	8760	6.2%
3	7344	5.2%
7	1416	1.0%

month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.5229295

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4487524
Coefficient of variation (CV)	0.52871219
Kurtosis	-1.2080577
Mean	6.5229295
Median Absolute Deviation (MAD)	3
Skewness	-0.0092942217
Sum	228720
Variance	11.893893
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	2976	8.5%
5	2976	8.5%
7	2976	8.5%
8	2976	8.5%
10	2976	8.5%
12	2976	8.5%
1	2976	8.5%
4	2880	8.2%
6	2880	8.2%
9	2880	8.2%
Other values (2)	5592	15.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2976	8.5%
2	2712	7.7%
3	2976	8.5%
4	2880	8.2%
5	2976	8.5%
6	2880	8.2%
7	2976	8.5%
8	2976	8.5%
9	2880	8.2%
10	2976	8.5%

Value	Count	Frequency (%)
12	2976	8.5%
11	2880	8.2%
10	2976	8.5%
9	2880	8.2%
8	2976	8.5%
7	2976	8.5%
6	2880	8.2%
5	2976	8.5%
4	2880	8.2%
3	2976	8.5%

day
Real number (ℝ)

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.729637

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.8002175
Coefficient of variation (CV)	0.55946729
Kurtosis	-1.1940295
Mean	15.729637
Median Absolute Deviation (MAD)	8
Skewness	0.0067598056
Sum	551544
Variance	77.443829
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	1152	3.3%
2	1152	3.3%
28	1152	3.3%
27	1152	3.3%
26	1152	3.3%
25	1152	3.3%
24	1152	3.3%
23	1152	3.3%
22	1152	3.3%
21	1152	3.3%
Other values (21)	23544	67.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1152	3.3%
2	1152	3.3%
3	1152	3.3%
4	1152	3.3%
5	1152	3.3%
6	1152	3.3%
7	1152	3.3%
8	1152	3.3%
9	1152	3.3%
10	1152	3.3%

Value	Count	Frequency (%)
31	672	1.9%
30	1056	3.0%
29	1080	3.1%
28	1152	3.3%
27	1152	3.3%
26	1152	3.3%
25	1152	3.3%
24	1152	3.3%
23	1152	3.3%
22	1152	3.3%

hour
Real number (ℝ)

ZEROS

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.5

Minimum	0
Maximum	23
Zeros	1461
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5.75
median	11.5
Q3	17.25
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	11.5

Descriptive statistics

Standard deviation	6.9222853
Coefficient of variation (CV)	0.60193785
Kurtosis	-1.2041745
Mean	11.5
Median Absolute Deviation (MAD)	6
Skewness	0
Sum	403236
Variance	47.918033
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
0	1461	4.2%
1	1461	4.2%
22	1461	4.2%
21	1461	4.2%
20	1461	4.2%
19	1461	4.2%
18	1461	4.2%
17	1461	4.2%
16	1461	4.2%
15	1461	4.2%
Other values (14)	20454	58.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1461	4.2%
1	1461	4.2%
2	1461	4.2%
3	1461	4.2%
4	1461	4.2%
5	1461	4.2%
6	1461	4.2%
7	1461	4.2%
8	1461	4.2%
9	1461	4.2%

Value	Count	Frequency (%)
23	1461	4.2%
22	1461	4.2%
21	1461	4.2%
20	1461	4.2%
19	1461	4.2%
18	1461	4.2%
17	1461	4.2%
16	1461	4.2%
15	1461	4.2%
14	1461	4.2%

PM2.5
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	557
Distinct (%)	1.6%
Missing	616
Missing (%)	1.8%
Infinite	0
Infinite (%)	0.0%
Mean	82.933372

Minimum	2
Maximum	680
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	2
5-th percentile	8
Q1	23
median	59
Q3	115
95-th percentile	243
Maximum	680
Range	678
Interquartile range (IQR)	92

Descriptive statistics

Standard deviation	80.933497
Coefficient of variation (CV)	0.97588577
Kurtosis	5.6001221
Mean	82.933372
Median Absolute Deviation (MAD)	41
Skewness	1.9734646
Sum	2856888.8
Variance	6550.231
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11	574	1.6%
12	566	1.6%
10	550	1.6%
14	538	1.5%
9	517	1.5%
13	496	1.4%
8	477	1.4%
15	476	1.4%
16	451	1.3%
3	408	1.2%
Other values (547)	29395	83.8%
(Missing)	616	1.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
3	408	1.2%
4	194	0.6%
5	240	0.7%
6	337	1.0%
7	378	1.1%
8	477	1.4%
9	517	1.5%
10	550	1.6%
11	574	1.6%

Value	Count	Frequency (%)
680	1	< 0.1%
666	1	< 0.1%
664	1	< 0.1%
663	1	< 0.1%
645	1	< 0.1%
639	1	< 0.1%
637	1	< 0.1%
636	1	< 0.1%
635	1	< 0.1%
633	1	< 0.1%

PM10
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	630
Distinct (%)	1.8%
Missing	429
Missing (%)	1.2%
Infinite	0
Infinite (%)	0.0%
Mean	109.0233

Minimum	2
Maximum	999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	2
5-th percentile	13
Q1	40
median	89
Q3	149
95-th percentile	281
Maximum	999
Range	997
Interquartile range (IQR)	109

Descriptive statistics

Standard deviation	91.573709
Coefficient of variation (CV)	0.8399462
Kurtosis	6.0181605
Mean	109.0233
Median Absolute Deviation (MAD)	53
Skewness	1.8458503
Sum	3776022.1
Variance	8385.7441
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18	312	0.9%
14	303	0.9%
25	300	0.9%
20	292	0.8%
24	291	0.8%
23	288	0.8%
16	287	0.8%
21	274	0.8%
15	273	0.8%
22	270	0.8%
Other values (620)	31745	90.5%
(Missing)	429	1.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	7	< 0.1%
3	21	0.1%
4	16	< 0.1%
5	175	0.5%
6	243	0.7%
7	117	0.3%
8	186	0.5%
9	199	0.6%
10	208	0.6%
11	233	0.7%

Value	Count	Frequency (%)
999	1	< 0.1%
987	1	< 0.1%
961	1	< 0.1%
917	1	< 0.1%
906	1	< 0.1%
828	1	< 0.1%
820	1	< 0.1%
814	1	< 0.1%
813	1	< 0.1%
807	1	< 0.1%

SO2
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	280
Distinct (%)	0.8%
Missing	474
Missing (%)	1.4%
Infinite	0
Infinite (%)	0.0%
Mean	17.590941

Minimum	1
Maximum	293
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	3
median	8
Q3	22
95-th percentile	67
Maximum	293
Range	292
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	23.600367
Coefficient of variation (CV)	1.3416204
Kurtosis	11.799211
Mean	17.590941
Median Absolute Deviation (MAD)	6
Skewness	2.8663252
Sum	608470.67
Variance	556.97731
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	7349	21.0%
3	2326	6.6%
4	1912	5.5%
5	1683	4.8%
6	1498	4.3%
7	1347	3.8%
8	1237	3.5%
9	1074	3.1%
10	952	2.7%
11	861	2.5%
Other values (270)	14351	40.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	133	0.4%
1.1424	1	< 0.1%
1.7136	2	< 0.1%
1.9992	3	< 0.1%
2	7349	21.0%
2.2848	7	< 0.1%
3	2326	6.6%
3.1416	1	< 0.1%
3.4272	1	< 0.1%
3.5	1	< 0.1%

Value	Count	Frequency (%)
293	1	< 0.1%
277	1	< 0.1%
274	1	< 0.1%
263	1	< 0.1%
247	1	< 0.1%
240	1	< 0.1%
239	1	< 0.1%
238	1	< 0.1%
229	1	< 0.1%
221	1	< 0.1%

NO2
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	376
Distinct (%)	1.1%
Missing	659
Missing (%)	1.9%
Infinite	0
Infinite (%)	0.0%
Mean	57.901643

Minimum	2
Maximum	270
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	2
5-th percentile	15
Q1	31
median	51
Q3	78
95-th percentile	124
Maximum	270
Range	268
Interquartile range (IQR)	47

Descriptive statistics

Standard deviation	35.150857
Coefficient of variation (CV)	0.60707876
Kurtosis	1.1222321
Mean	57.901643
Median Absolute Deviation (MAD)	23
Skewness	1.0277689
Sum	1992106
Variance	1235.5828
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	491	1.4%
30	486	1.4%
21	481	1.4%
29	473	1.3%
26	465	1.3%
35	464	1.3%
24	463	1.3%
25	458	1.3%
36	451	1.3%
31	450	1.3%
Other values (366)	29723	84.8%
(Missing)	659	1.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	70	0.2%
3	21	0.1%
4	29	0.1%
5	35	0.1%
6	41	0.1%
7	58	0.2%
8	88	0.3%
9	115	0.3%
10	173	0.5%
11	178	0.5%

Value	Count	Frequency (%)
270	1	< 0.1%
239	1	< 0.1%
233	1	< 0.1%
231	1	< 0.1%
230	1	< 0.1%
226	3	< 0.1%
225	2	< 0.1%
224	1	< 0.1%
223	1	< 0.1%
222	1	< 0.1%

CO
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	117
Distinct (%)	0.4%
Missing	1753
Missing (%)	5.0%
Infinite	0
Infinite (%)	0.0%
Mean	1271.2944

Minimum	100
Maximum	10000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	100
5-th percentile	300
Q1	500
median	900
Q3	1600
95-th percentile	3600
Maximum	10000
Range	9900
Interquartile range (IQR)	1100

Descriptive statistics

Standard deviation	1164.8549
Coefficient of variation (CV)	0.91627476
Kurtosis	9.1945221
Mean	1271.2944
Median Absolute Deviation (MAD)	499
Skewness	2.5382105
Sum	42348087
Variance	1356887
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
400	2417	6.9%
300	2341	6.7%
600	2330	6.6%
500	2299	6.6%
700	2218	6.3%
800	2043	5.8%
900	1926	5.5%
1000	1715	4.9%
1100	1504	4.3%
1200	1426	4.1%
Other values (107)	13092	37.3%
(Missing)	1753	5.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100	481	1.4%
200	1159	3.3%
300	2341	6.7%
400	2417	6.9%
500	2299	6.6%
600	2330	6.6%
700	2218	6.3%
800	2043	5.8%
900	1926	5.5%
1000	1715	4.9%

Value	Count	Frequency (%)
10000	7	< 0.1%
9900	1	< 0.1%
9800	5	< 0.1%
9700	3	< 0.1%
9600	1	< 0.1%
9500	3	< 0.1%
9400	1	< 0.1%
9300	3	< 0.1%
9200	7	< 0.1%
9100	7	< 0.1%

O3
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	767
Distinct (%)	2.3%
Missing	1173
Missing (%)	3.3%
Infinite	0
Infinite (%)	0.0%
Mean	55.795044

Minimum	0.2142
Maximum	415
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	0.2142
5-th percentile	2
Q1	7
median	41
Q3	81
95-th percentile	181
Maximum	415
Range	414.7858
Interquartile range (IQR)	74

Descriptive statistics

Standard deviation	57.436983
Coefficient of variation (CV)	1.029428
Kurtosis	1.8349403
Mean	55.795044
Median Absolute Deviation (MAD)	36
Skewness	1.4020107
Sum	1890949.8
Variance	3299.007
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	4819	13.7%
1	1144	3.3%
3	692	2.0%
4	564	1.6%
5	427	1.2%
6	410	1.2%
7	300	0.9%
12	299	0.9%
8	292	0.8%
9	279	0.8%
Other values (757)	24665	70.3%
(Missing)	1173	3.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2142	21	0.1%
0.4284	24	0.1%
0.6426	12	< 0.1%
0.8568	11	< 0.1%
1	1144	3.3%
1.071	12	< 0.1%
1.2852	5	< 0.1%
1.4994	10	< 0.1%
1.7136	3	< 0.1%
1.9278	9	< 0.1%

Value	Count	Frequency (%)
415	1	< 0.1%
356	1	< 0.1%
352	2	< 0.1%
346	1	< 0.1%
340	1	< 0.1%
339	1	< 0.1%
335	2	< 0.1%
332	1	< 0.1%
331	1	< 0.1%
325	1	< 0.1%

TEMP
Real number (ℝ)

HIGH CORRELATION

Distinct	967
Distinct (%)	2.8%
Missing	20
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	13.584607

Minimum	-16.8
Maximum	40.5
Zeros	196
Zeros (%)	0.6%
Negative	5308
Negative (%)	15.1%
Memory size	274.1 KiB

Quantile statistics

Minimum	-16.8
5-th percentile	-4
Q1	3.1
median	14.5
Q3	23.3
95-th percentile	30.6
Maximum	40.5
Range	57.3
Interquartile range (IQR)	20.2

Descriptive statistics

Standard deviation	11.399097
Coefficient of variation (CV)	0.83911861
Kurtosis	-1.1573086
Mean	13.584607
Median Absolute Deviation (MAD)	9.8
Skewness	-0.094157845
Sum	476058.98
Variance	129.93941
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	249	0.7%
1	240	0.7%
2	203	0.6%
0	196	0.6%
-2	186	0.5%
-1	186	0.5%
24.1	154	0.4%
21.7	150	0.4%
-4	143	0.4%
22.5	139	0.4%
Other values (957)	33198	94.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-16.8	2	< 0.1%
-16.3	1	< 0.1%
-16.2	1	< 0.1%
-16.1	1	< 0.1%
-16	1	< 0.1%
-15.9	3	< 0.1%
-15.8	2	< 0.1%
-15.6	1	< 0.1%
-15.4	1	< 0.1%
-15.3	2	< 0.1%

Value	Count	Frequency (%)
40.5	1	< 0.1%
40.3	1	< 0.1%
40.1	1	< 0.1%
39.2	1	< 0.1%
38.8	1	< 0.1%
38.4	1	< 0.1%
38.3	1	< 0.1%
38.1	2	< 0.1%
38	1	< 0.1%
37.9	1	< 0.1%

PRES
Real number (ℝ)

HIGH CORRELATION

Distinct	600
Distinct (%)	1.7%
Missing	20
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1011.8469

Minimum	985.9
Maximum	1042
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	985.9
5-th percentile	996.1
Q1	1003.3
median	1011.4
Q3	1020.1
95-th percentile	1028.8
Maximum	1042
Range	56.1
Interquartile range (IQR)	16.8

Descriptive statistics

Standard deviation	10.404047
Coefficient of variation (CV)	0.010282234
Kurtosis	-0.88797034
Mean	1011.8469
Median Absolute Deviation (MAD)	8.5
Skewness	0.11150001
Sum	35459163
Variance	108.24419
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1023	256	0.7%
1019	252	0.7%
1024	249	0.7%
1025	248	0.7%
1020	239	0.7%
1017	238	0.7%
1021	237	0.7%
1022	237	0.7%
1018	233	0.7%
1026	224	0.6%
Other values (590)	32631	93.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
985.9	1	< 0.1%
986.3	1	< 0.1%
987.2	1	< 0.1%
987.5	1	< 0.1%
987.7	2	< 0.1%
987.8	3	< 0.1%
987.9	1	< 0.1%
988	4	< 0.1%
988.1	4	< 0.1%
988.2	2	< 0.1%

Value	Count	Frequency (%)
1042	1	< 0.1%
1041.8	1	< 0.1%
1041.6	1	< 0.1%
1041.4	1	< 0.1%
1041.2	2	< 0.1%
1041.1	2	< 0.1%
1041	2	< 0.1%
1040.9	1	< 0.1%
1040.8	3	< 0.1%
1040.7	1	< 0.1%

DEWP
Real number (ℝ)

HIGH CORRELATION

Distinct	604
Distinct (%)	1.7%
Missing	20
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	3.1230624

Minimum	-35.3
Maximum	28.5
Zeros	66
Zeros (%)	0.2%
Negative	14885
Negative (%)	42.5%
Memory size	274.1 KiB

Quantile statistics

Minimum	-35.3
5-th percentile	-19.4
Q1	-8.1
median	3.8
Q3	15.6
95-th percentile	22.4
Maximum	28.5
Range	63.8
Interquartile range (IQR)	23.7

Descriptive statistics

Standard deviation	13.688896
Coefficient of variation (CV)	4.3831644
Kurtosis	-1.1013944
Mean	3.1230624
Median Absolute Deviation (MAD)	11.9
Skewness	-0.21320853
Sum	109444.6
Variance	187.38587
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17.6	143	0.4%
17	133	0.4%
17.2	129	0.4%
18.8	128	0.4%
17.8	126	0.4%
17.9	125	0.4%
18.3	124	0.4%
16.8	124	0.4%
17.1	124	0.4%
18.2	121	0.3%
Other values (594)	33767	96.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-35.3	1	< 0.1%
-35.1	1	< 0.1%
-35	1	< 0.1%
-34.8	1	< 0.1%
-34.5	1	< 0.1%
-34.3	2	< 0.1%
-34.2	1	< 0.1%
-34.1	1	< 0.1%
-33.8	1	< 0.1%
-33.7	1	< 0.1%

Value	Count	Frequency (%)
28.5	1	< 0.1%
27.8	5	< 0.1%
27.7	1	< 0.1%
27.6	1	< 0.1%
27.5	3	< 0.1%
27.4	1	< 0.1%
27.3	4	< 0.1%
27.2	4	< 0.1%
27.1	2	< 0.1%
27	6	< 0.1%

RAIN
Real number (ℝ)

SKEWED ZEROS

Distinct	127
Distinct (%)	0.4%
Missing	20
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.067420957

Minimum	0
Maximum	72.5
Zeros	33664
Zeros (%)	96.0%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	72.5
Range	72.5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.91005591
Coefficient of variation (CV)	13.498116
Kurtosis	1822.1806
Mean	0.067420957
Median Absolute Deviation (MAD)	0
Skewness	34.719336
Sum	2362.7
Variance	0.82820177
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	33664	96.0%
0.1	314	0.9%
0.2	161	0.5%
0.3	107	0.3%
0.5	73	0.2%
0.4	72	0.2%
0.6	67	0.2%
0.7	49	0.1%
0.9	48	0.1%
0.8	39	0.1%
Other values (117)	450	1.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33664	96.0%
0.1	314	0.9%
0.2	161	0.5%
0.3	107	0.3%
0.4	72	0.2%
0.5	73	0.2%
0.6	67	0.2%
0.7	49	0.1%
0.8	39	0.1%
0.9	48	0.1%

Value	Count	Frequency (%)
72.5	1	< 0.1%
46.4	1	< 0.1%
40.7	1	< 0.1%
36.6	1	< 0.1%
33.7	1	< 0.1%
33.1	1	< 0.1%
29.3	1	< 0.1%
26.8	1	< 0.1%
24.1	1	< 0.1%
23.7	1	< 0.1%

wd
Categorical

Distinct	16
Distinct (%)	< 0.1%
Missing	81
Missing (%)	0.2%
Memory size	274.1 KiB

NE	5140
ENE	3950
SW	3359
E	2608
NNE	2445
Other values (11)	17481

Length

Max length	3
Median length	2
Mean length	2.256839
Min length	1

Characters and Unicode

Total characters	78951
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NNW
2nd row	N
3rd row	NNW
4th row	NW
5th row	N

Common Values

Value	Count	Frequency (%)
NE	5140	14.7%
ENE	3950	11.3%
SW	3359	9.6%
E	2608	7.4%
NNE	2445	7.0%
WSW	2212	6.3%
SSW	2098	6.0%
N	2066	5.9%
NW	1860	5.3%
ESE	1717	4.9%
Other values (6)	7528	21.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ne	5140	14.7%
ene	3950	11.3%
sw	3359	9.6%
e	2608	7.5%
nne	2445	7.0%
wsw	2212	6.3%
ssw	2098	6.0%
n	2066	5.9%
nw	1860	5.3%
ese	1717	4.9%
Other values (6)	7528	21.5%

Most occurring characters

Value	Count	Frequency (%)
E	23890	30.3%
N	22185	28.1%
W	16703	21.2%
S	16173	20.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	78951	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	23890	30.3%
N	22185	28.1%
W	16703	21.2%
S	16173	20.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	78951	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	23890	30.3%
N	22185	28.1%
W	16703	21.2%
S	16173	20.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	78951	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	23890	30.3%
N	22185	28.1%
W	16703	21.2%
S	16173	20.5%

WSPM
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	91
Distinct (%)	0.3%
Missing	14
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.7084964

Minimum	0
Maximum	11.2
Zeros	1353
Zeros (%)	3.9%
Negative	0
Negative (%)	0.0%
Memory size	274.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0.2
Q1	0.9
median	1.4
Q3	2.2
95-th percentile	4.1
Maximum	11.2
Range	11.2
Interquartile range (IQR)	1.3

Descriptive statistics

Standard deviation	1.2040711
Coefficient of variation (CV)	0.70475481
Kurtosis	2.4952557
Mean	1.7084964
Median Absolute Deviation (MAD)	0.6
Skewness	1.365037
Sum	59882.8
Variance	1.4497871
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.2	1891	5.4%
1.1	1842	5.3%
1	1747	5.0%
1.3	1640	4.7%
0.9	1604	4.6%
1.4	1581	4.5%
0.8	1443	4.1%
1.5	1442	4.1%
0.7	1366	3.9%
0	1353	3.9%
Other values (81)	19141	54.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1353	3.9%
0.1	397	1.1%
0.2	430	1.2%
0.3	191	0.5%
0.4	602	1.7%
0.5	883	2.5%
0.6	1123	3.2%
0.7	1366	3.9%
0.8	1443	4.1%
0.9	1604	4.6%

Value	Count	Frequency (%)
11.2	1	< 0.1%
9.2	1	< 0.1%
9.1	1	< 0.1%
8.9	1	< 0.1%
8.8	1	< 0.1%
8.6	1	< 0.1%
8.5	1	< 0.1%
8.4	3	< 0.1%
8.3	2	< 0.1%
8.2	2	< 0.1%

station
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	274.1 KiB

Guanyuan	35064

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	280512
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Guanyuan
2nd row	Guanyuan
3rd row	Guanyuan
4th row	Guanyuan
5th row	Guanyuan

Common Values

Value	Count	Frequency (%)
Guanyuan	35064	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
guanyuan	35064	100.0%

Most occurring characters

Value	Count	Frequency (%)
u	70128	25.0%
a	70128	25.0%
n	70128	25.0%
G	35064	12.5%
y	35064	12.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	245448	87.5%
Uppercase Letter	35064	12.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	70128	28.6%
a	70128	28.6%
n	70128	28.6%
y	35064	14.3%

Uppercase Letter

Value	Count	Frequency (%)
G	35064	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	280512	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	70128	25.0%
a	70128	25.0%
n	70128	25.0%
G	35064	12.5%
y	35064	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	280512	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
u	70128	25.0%
a	70128	25.0%
n	70128	25.0%
G	35064	12.5%
y	35064	12.5%

Auto

Heatmap
Table

	CO	DEWP	NO2	No	O3	PM10	PM2.5	PRES	RAIN	SO2	TEMP	WSPM	day	hour	month	wd	year
CO	1.000	0.119	0.753	-0.034	-0.440	0.738	0.846	0.067	0.008	0.592	-0.195	-0.412	0.010	-0.040	0.067	0.108	0.077
DEWP	0.119	1.000	-0.041	-0.133	0.291	0.168	0.258	-0.782	0.174	-0.318	0.821	-0.255	0.023	-0.013	0.260	0.116	0.158
NO2	0.753	-0.041	1.000	-0.057	-0.660	0.624	0.654	0.168	-0.084	0.542	-0.325	-0.516	0.012	-0.067	0.058	0.126	0.073
No	-0.034	-0.133	-0.057	1.000	-0.054	-0.060	-0.054	0.228	0.001	-0.229	-0.103	0.111	0.018	0.001	0.044	0.117	0.862
O3	-0.440	0.291	-0.660	-0.054	1.000	-0.184	-0.222	-0.450	-0.003	-0.239	0.606	0.411	-0.005	0.278	-0.143	0.164	0.045
PM10	0.738	0.168	0.624	-0.060	-0.184	1.000	0.895	-0.117	-0.083	0.531	-0.006	-0.252	0.034	0.042	-0.021	0.084	0.054
PM2.5	0.846	0.258	0.654	-0.054	-0.222	0.895	1.000	-0.107	-0.018	0.544	-0.009	-0.339	0.015	0.002	0.023	0.099	0.053
PRES	0.067	-0.782	0.168	0.228	-0.450	-0.117	-0.107	1.000	-0.085	0.265	-0.831	0.049	0.013	-0.036	0.003	0.076	0.168
RAIN	0.008	0.174	-0.084	0.001	-0.003	-0.083	-0.018	-0.085	1.000	-0.165	0.041	-0.021	-0.005	-0.004	0.043	0.004	0.009
SO2	0.592	-0.318	0.542	-0.229	-0.239	0.531	0.544	0.265	-0.165	1.000	-0.384	-0.121	-0.002	0.003	-0.196	0.051	0.100
TEMP	-0.195	0.821	-0.325	-0.103	0.606	-0.006	-0.009	-0.831	0.041	-0.384	1.000	0.097	0.017	0.145	0.123	0.104	0.147
WSPM	-0.412	-0.255	-0.516	0.111	0.411	-0.252	-0.339	0.049	-0.021	-0.121	0.097	1.000	-0.008	0.171	-0.178	0.159	0.077
day	0.010	0.023	0.012	0.018	-0.005	0.034	0.015	0.013	-0.005	-0.002	0.017	-0.008	1.000	0.000	0.010	0.027	0.000
hour	-0.040	-0.013	-0.067	0.001	0.278	0.042	0.002	-0.036	-0.004	0.003	0.145	0.171	0.000	1.000	0.000	0.131	0.000
month	0.067	0.260	0.058	0.044	-0.143	-0.021	0.023	0.003	0.043	-0.196	0.123	-0.178	0.010	0.000	1.000	0.087	0.249
wd	0.108	0.116	0.126	0.117	0.164	0.084	0.099	0.076	0.004	0.051	0.104	0.159	0.027	0.131	0.087	1.000	0.131
year	0.077	0.158	0.073	0.862	0.045	0.054	0.053	0.168	0.009	0.100	0.147	0.077	0.000	0.000	0.249	0.131	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	No	year	month	day	hour	PM2.5	PM10	SO2	NO2	CO	O3	TEMP	PRES	DEWP	wd	WSPM	station
0	1	2013	3	1	0	4.0	4.0	14.0	20.0	300.0	69.0	-0.7	1023.0	-18.8	NNW	4.4	Guanyuan
1	2	2013	3	1	1	4.0	4.0	13.0	17.0	300.0	72.0	-1.1	1023.2	-18.2	N	4.7	Guanyuan
2	3	2013	3	1	2	3.0	3.0	10.0	19.0	300.0	69.0	-1.1	1023.5	-18.2	NNW	5.6	Guanyuan
3	4	2013	3	1	3	3.0	6.0	7.0	24.0	400.0	62.0	-1.4	1024.5	-19.4	NW	3.1	Guanyuan
4	5	2013	3	1	4	3.0	6.0	5.0	14.0	400.0	71.0	-2.0	1025.2	-19.5	N	2.0	Guanyuan
5	6	2013	3	1	5	3.0	6.0	6.0	14.0	400.0	71.0	-2.2	1025.6	-19.6	N	3.7	Guanyuan
6	7	2013	3	1	6	6.0	6.0	6.0	20.0	400.0	66.0	-2.6	1026.5	-19.1	NNE	2.5	Guanyuan
7	8	2013	3	1	7	3.0	3.0	7.0	26.0	400.0	61.0	-1.6	1027.4	-19.1	NNW	3.8	Guanyuan
8	9	2013	3	1	8	3.0	6.0	9.0	37.0	500.0	50.0	0.1	1028.3	-19.2	NNW	4.1	Guanyuan
9	10	2013	3	1	9	7.0	11.0	9.0	30.0	400.0	58.0	1.2	1028.5	-19.3	N	2.6	Guanyuan

	No	year	month	day	hour	PM2.5	PM10	SO2	NO2	CO	O3	TEMP	PRES	DEWP	wd	WSPM	station
35054	35055	2017	2	28	14	3.0	74.0	2.0	15.0	200.0	84.0	14.6	1013.3	-15.6	N	3.6	Guanyuan
35055	35056	2017	2	28	15	8.0	25.0	2.0	17.0	200.0	87.0	15.4	1013.0	-15.0	NNW	3.3	Guanyuan
35056	35057	2017	2	28	16	8.0	17.0	2.0	16.0	300.0	88.0	14.9	1012.6	-15.4	NW	2.1	Guanyuan
35057	35058	2017	2	28	17	11.0	23.0	3.0	19.0	300.0	83.0	14.2	1012.5	-14.9	NW	3.1	Guanyuan
35058	35059	2017	2	28	18	10.0	33.0	2.0	22.0	300.0	78.0	13.4	1013.0	-15.5	WNW	1.4	Guanyuan
35059	35060	2017	2	28	19	13.0	37.0	3.0	36.0	400.0	60.0	12.5	1013.5	-16.2	NW	2.4	Guanyuan
35060	35061	2017	2	28	20	20.0	43.0	4.0	48.0	500.0	43.0	11.6	1013.6	-15.1	WNW	0.9	Guanyuan
35061	35062	2017	2	28	21	16.0	33.0	5.0	39.0	500.0	50.0	10.8	1014.2	-13.3	NW	1.1	Guanyuan
35062	35063	2017	2	28	22	11.0	24.0	5.0	47.0	500.0	41.0	10.5	1014.4	-12.9	NNW	1.2	Guanyuan
35063	35064	2017	2	28	23	15.0	27.0	5.0	53.0	600.0	33.0	8.6	1014.1	-15.9	NNE	1.3	Guanyuan

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample